Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 79330 |
| Missing cells | 28 |
| Missing cells (%) | < 0.1% |
| Duplicate rows | 25902 |
| Duplicate rows (%) | 32.7% |
| Total size in memory | 18.8 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Categorical | 20 |
|---|---|
| Numeric | 11 |
| Dataset has 25902 (32.7%) duplicate rows | Duplicates |
Country has a high cardinality: 166 distinct values | High cardinality |
Agent has a high cardinality: 224 distinct values | High cardinality |
Company has a high cardinality: 208 distinct values | High cardinality |
ReservationStatusDate has a high cardinality: 864 distinct values | High cardinality |
ReservationStatus is highly correlated with IsCanceled | High correlation |
IsCanceled is highly correlated with ReservationStatus | High correlation |
PreviousBookingsNotCanceled is highly skewed (γ1 = 23.1165642) | Skewed |
ADR is highly skewed (γ1 = 23.16174514) | Skewed |
LeadTime has 3109 (3.9%) zeros | Zeros |
StaysInWeekendNights has 37817 (47.7%) zeros | Zeros |
StaysInWeekNights has 4963 (6.3%) zeros | Zeros |
PreviousCancellations has 73941 (93.2%) zeros | Zeros |
PreviousBookingsNotCanceled has 77742 (98.0%) zeros | Zeros |
BookingChanges has 69062 (87.1%) zeros | Zeros |
DaysInWaitingList has 75887 (95.7%) zeros | Zeros |
ADR has 1208 (1.5%) zeros | Zeros |
TotalOfSpecialRequests has 47957 (60.5%) zeros | Zeros |
Reproduction
| Analysis started | 2021-03-02 23:10:15.817822 |
|---|---|
| Analysis finished | 2021-03-02 23:11:37.553424 |
| Duration | 1 minute and 21.74 seconds |
| Software version | pandas-profiling v2.11.0 |
| Download configuration | config.yaml |
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 79330 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79330 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79330 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79330 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 46228 | |
| 1 | 33102 |
| Distinct | 453 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 109.7357242 |
|---|---|
| Minimum | 0 |
| Maximum | 629 |
| Zeros | 3109 |
| Zeros (%) | 3.9% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 23 |
| median | 74 |
| Q3 | 163 |
| 95-th percentile | 334.55 |
| Maximum | 629 |
| Range | 629 |
| Interquartile range (IQR) | 140 |
Descriptive statistics
| Standard deviation | 110.9485258 |
|---|---|
| Coefficient of variation (CV) | 1.011052021 |
| Kurtosis | 1.804542062 |
| Mean | 109.7357242 |
| Median Absolute Deviation (MAD) | 61 |
| Skewness | 1.389834639 |
| Sum | 8705335 |
| Variance | 12309.57537 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 3109 | 3.9% |
| 1 | 1865 | 2.4% |
| 2 | 1130 | 1.4% |
| 4 | 1052 | 1.3% |
| 3 | 1022 | 1.3% |
| 5 | 965 | 1.2% |
| 6 | 907 | 1.1% |
| 7 | 758 | 1.0% |
| 8 | 750 | 0.9% |
| 12 | 736 | 0.9% |
| Other values (443) | 67036 |
| Value | Count | Frequency (%) |
| 0 | 3109 | |
| 1 | 1865 | |
| 2 | 1130 | 1.4% |
| 3 | 1022 | 1.3% |
| 4 | 1052 | 1.3% |
| Value | Count | Frequency (%) |
| 629 | 17 | |
| 626 | 30 | |
| 622 | 17 | |
| 615 | 17 | |
| 608 | 17 |
ArrivalDateYear
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 2016 | |
|---|---|
| 2017 | |
| 2015 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Characters and Unicode
| Total characters | 317320 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2015 |
|---|---|
| 2nd row | 2015 |
| 3rd row | 2015 |
| 4th row | 2015 |
| 5th row | 2015 |
| Value | Count | Frequency (%) |
| 2016 | 38140 | |
| 2017 | 27508 | |
| 2015 | 13682 | 17.2% |
| Value | Count | Frequency (%) |
| 2016 | 38140 | |
| 2017 | 27508 | |
| 2015 | 13682 | 17.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 79330 | |
| 0 | 79330 | |
| 1 | 79330 | |
| 6 | 38140 | |
| 7 | 27508 | 8.7% |
| 5 | 13682 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 317320 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 79330 | |
| 0 | 79330 | |
| 1 | 79330 | |
| 6 | 38140 | |
| 7 | 27508 | 8.7% |
| 5 | 13682 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 317320 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 79330 | |
| 0 | 79330 | |
| 1 | 79330 | |
| 6 | 38140 | |
| 7 | 27508 | 8.7% |
| 5 | 13682 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 317320 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 79330 | |
| 0 | 79330 | |
| 1 | 79330 | |
| 6 | 38140 | |
| 7 | 27508 | 8.7% |
| 5 | 13682 | 4.3% |
ArrivalDateMonth
Categorical
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| August | |
|---|---|
| May | |
| July | |
| June | |
| October | |
| Other values (7) |
Length
| Max length | 9 |
|---|---|
| Median length | 6 |
| Mean length | 5.872066053 |
| Min length | 3 |
Characters and Unicode
| Total characters | 465831 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | July |
|---|---|
| 2nd row | July |
| 3rd row | July |
| 4th row | July |
| 5th row | July |
| Value | Count | Frequency (%) |
| August | 8983 | |
| May | 8232 | |
| July | 8088 | |
| June | 7894 | |
| October | 7605 | |
| April | 7480 | |
| September | 7400 | |
| March | 6458 | |
| February | 4965 | |
| November | 4357 | |
| Other values (2) | 7868 |
| Value | Count | Frequency (%) |
| august | 8983 | |
| may | 8232 | |
| july | 8088 | |
| june | 7894 | |
| october | 7605 | |
| april | 7480 | |
| september | 7400 | |
| march | 6458 | |
| february | 4965 | |
| november | 4357 | |
| Other values (2) | 7868 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 63774 | |
| r | 51098 | 11.0% |
| u | 42649 | 9.2% |
| b | 28459 | 6.1% |
| a | 27127 | 5.8% |
| y | 25021 | 5.4% |
| t | 23988 | 5.1% |
| J | 19718 | 4.2% |
| c | 18195 | 3.9% |
| A | 16463 | 3.5% |
| Other values (16) | 149339 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 386501 | |
| Uppercase Letter | 79330 | 17.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 63774 | |
| r | 51098 | |
| u | 42649 | |
| b | 28459 | 7.4% |
| a | 27127 | 7.0% |
| y | 25021 | 6.5% |
| t | 23988 | 6.2% |
| c | 18195 | 4.7% |
| m | 15889 | 4.1% |
| l | 15568 | 4.0% |
| Other values (8) | 74733 |
| Value | Count | Frequency (%) |
| J | 19718 | |
| A | 16463 | |
| M | 14690 | |
| O | 7605 | 9.6% |
| S | 7400 | 9.3% |
| F | 4965 | 6.3% |
| N | 4357 | 5.5% |
| D | 4132 | 5.2% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 465831 |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 63774 | |
| r | 51098 | 11.0% |
| u | 42649 | 9.2% |
| b | 28459 | 6.1% |
| a | 27127 | 5.8% |
| y | 25021 | 5.4% |
| t | 23988 | 5.1% |
| J | 19718 | 4.2% |
| c | 18195 | 3.9% |
| A | 16463 | 3.5% |
| Other values (16) | 149339 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 465831 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 63774 | |
| r | 51098 | 11.0% |
| u | 42649 | 9.2% |
| b | 28459 | 6.1% |
| a | 27127 | 5.8% |
| y | 25021 | 5.4% |
| t | 23988 | 5.1% |
| J | 19718 | 4.2% |
| c | 18195 | 3.9% |
| A | 16463 | 3.5% |
| Other values (16) | 149339 |
ArrivalDateWeekNumber
Real number (ℝ≥0)
| Distinct | 53 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 27.17744863 |
|---|---|
| Minimum | 1 |
| Maximum | 53 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 5 |
| Q1 | 17 |
| median | 27 |
| Q3 | 38 |
| 95-th percentile | 49 |
| Maximum | 53 |
| Range | 52 |
| Interquartile range (IQR) | 21 |
Descriptive statistics
| Standard deviation | 13.39852289 |
|---|---|
| Coefficient of variation (CV) | 0.4930014982 |
| Kurtosis | -0.9641446539 |
| Mean | 27.17744863 |
| Median Absolute Deviation (MAD) | 11 |
| Skewness | -0.00974797619 |
| Sum | 2155987 |
| Variance | 179.5204157 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 33 | 2383 | 3.0% |
| 42 | 2032 | 2.6% |
| 20 | 2016 | 2.5% |
| 30 | 2011 | 2.5% |
| 32 | 1991 | 2.5% |
| 17 | 1965 | 2.5% |
| 25 | 1959 | 2.5% |
| 34 | 1950 | 2.5% |
| 21 | 1948 | 2.5% |
| 18 | 1914 | 2.4% |
| Other values (43) | 59161 |
| Value | Count | Frequency (%) |
| 1 | 704 | |
| 2 | 761 | |
| 3 | 766 | |
| 4 | 968 | |
| 5 | 886 |
| Value | Count | Frequency (%) |
| 53 | 1198 | |
| 52 | 603 | |
| 51 | 503 | |
| 50 | 1056 | |
| 49 | 1066 |
ArrivalDateDayOfMonth
Real number (ℝ≥0)
| Distinct | 31 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.78662549 |
|---|---|
| Minimum | 1 |
| Maximum | 31 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 8 |
| median | 16 |
| Q3 | 23 |
| 95-th percentile | 29 |
| Maximum | 31 |
| Range | 30 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 8.728450546 |
|---|---|
| Coefficient of variation (CV) | 0.5529016035 |
| Kurtosis | -1.181540608 |
| Mean | 15.78662549 |
| Median Absolute Deviation (MAD) | 8 |
| Skewness | -0.006601999321 |
| Sum | 1252353 |
| Variance | 76.18584893 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 17 | 3012 | 3.8% |
| 15 | 2874 | 3.6% |
| 5 | 2857 | 3.6% |
| 20 | 2835 | 3.6% |
| 25 | 2823 | 3.6% |
| 26 | 2748 | 3.5% |
| 19 | 2747 | 3.5% |
| 9 | 2692 | 3.4% |
| 8 | 2676 | 3.4% |
| 28 | 2670 | 3.4% |
| Other values (21) | 51396 |
| Value | Count | Frequency (%) |
| 1 | 2332 | |
| 2 | 2667 | |
| 3 | 2530 | |
| 4 | 2461 | |
| 5 | 2857 |
| Value | Count | Frequency (%) |
| 31 | 1352 | |
| 30 | 2380 | |
| 29 | 2366 | |
| 28 | 2670 | |
| 27 | 2537 |
| Distinct | 14 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.7951846716 |
|---|---|
| Minimum | 0 |
| Maximum | 16 |
| Zeros | 37817 |
| Zeros (%) | 47.7% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 2 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 0.8850263828 |
|---|---|
| Coefficient of variation (CV) | 1.112982197 |
| Kurtosis | 5.003917041 |
| Mean | 0.7951846716 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.133843442 |
| Sum | 63082 |
| Variance | 0.7832716982 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 37817 | |
| 1 | 21434 | |
| 2 | 19333 | |
| 3 | 323 | 0.4% |
| 4 | 297 | 0.4% |
| 5 | 44 | 0.1% |
| 6 | 40 | 0.1% |
| 8 | 24 | < 0.1% |
| 7 | 6 | < 0.1% |
| 9 | 6 | < 0.1% |
| Other values (4) | 6 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 37817 | |
| 1 | 21434 | |
| 2 | 19333 | |
| 3 | 323 | 0.4% |
| 4 | 297 | 0.4% |
| Value | Count | Frequency (%) |
| 16 | 1 | < 0.1% |
| 14 | 2 | < 0.1% |
| 13 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 9 | 6 |
| Distinct | 29 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.182957267 |
|---|---|
| Minimum | 0 |
| Maximum | 41 |
| Zeros | 4963 |
| Zeros (%) | 6.3% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 5 |
| Maximum | 41 |
| Range | 41 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 1.456416186 |
|---|---|
| Coefficient of variation (CV) | 0.6671757657 |
| Kurtosis | 32.49062966 |
| Mean | 2.182957267 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.955993664 |
| Sum | 173174 |
| Variance | 2.121148108 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 2 | 26403 | |
| 1 | 21088 | |
| 3 | 16371 | |
| 4 | 6141 | 7.7% |
| 0 | 4963 | 6.3% |
| 5 | 3266 | 4.1% |
| 6 | 379 | 0.5% |
| 7 | 201 | 0.3% |
| 8 | 160 | 0.2% |
| 10 | 145 | 0.2% |
| Other values (19) | 213 | 0.3% |
| Value | Count | Frequency (%) |
| 0 | 4963 | 6.3% |
| 1 | 21088 | |
| 2 | 26403 | |
| 3 | 16371 | |
| 4 | 6141 | 7.7% |
| Value | Count | Frequency (%) |
| 41 | 1 | |
| 35 | 1 | |
| 34 | 1 | |
| 30 | 1 | |
| 25 | 1 |
Adults
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 2 | |
|---|---|
| 1 | |
| 3 | 4775 |
| 0 | 390 |
| 4 | 31 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 79330 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 2 |
| 3rd row | 1 |
| 4th row | 2 |
| 5th row | 2 |
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79330 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79330 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79330 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 2 | 58255 | |
| 1 | 15879 | 20.0% |
| 3 | 4775 | 6.0% |
| 0 | 390 | 0.5% |
| 4 | 31 | < 0.1% |
Children
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 4 |
| Missing (%) | < 0.1% |
| Memory size | 619.9 KiB |
| 0.0 | |
|---|---|
| 1.0 | 3023 |
| 2.0 | 2024 |
| 3.0 | 59 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 237978 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
| Value | Count | Frequency (%) |
| 0.0 | 74220 | |
| 1.0 | 3023 | 3.8% |
| 2.0 | 2024 | 2.6% |
| 3.0 | 59 | 0.1% |
| (Missing) | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| 0.0 | 74220 | |
| 1.0 | 3023 | 3.8% |
| 2.0 | 2024 | 2.6% |
| 3.0 | 59 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 153546 | |
| . | 79326 | |
| 1 | 3023 | 1.3% |
| 2 | 2024 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 158652 | |
| Other Punctuation | 79326 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 153546 | |
| 1 | 3023 | 1.9% |
| 2 | 2024 | 1.3% |
| 3 | 59 | < 0.1% |
| Value | Count | Frequency (%) |
| . | 79326 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 237978 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 153546 | |
| . | 79326 | |
| 1 | 3023 | 1.3% |
| 2 | 2024 | 0.9% |
| 3 | 59 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 237978 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 153546 | |
| . | 79326 | |
| 1 | 3023 | 1.3% |
| 2 | 2024 | 0.9% |
| 3 | 59 | < 0.1% |
Babies
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 0 | |
|---|---|
| 1 | 361 |
| 2 | 6 |
| 9 | 1 |
| 10 | 1 |
Length
| Max length | 2 |
|---|---|
| Median length | 1 |
| Mean length | 1.000012606 |
| Min length | 1 |
Characters and Unicode
| Total characters | 79331 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 2 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 78961 | |
| 1 | 361 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 78961 | |
| 1 | 361 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
| 10 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 78962 | |
| 1 | 362 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79331 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 78962 | |
| 1 | 362 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79331 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 78962 | |
| 1 | 362 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79331 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 78962 | |
| 1 | 362 | 0.5% |
| 2 | 6 | < 0.1% |
| 9 | 1 | < 0.1% |
Meal
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| BB | |
|---|---|
| SC | |
| HB | |
| FB | 44 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 713970 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HB |
|---|---|
| 2nd row | BB |
| 3rd row | BB |
| 4th row | BB |
| 5th row | BB |
| Value | Count | Frequency (%) |
| BB | 62305 | |
| SC | 10564 | 13.3% |
| HB | 6417 | 8.1% |
| FB | 44 | 0.1% |
| Value | Count | Frequency (%) |
| bb | 62305 | |
| sc | 10564 | 13.3% |
| hb | 6417 | 8.1% |
| fb | 44 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 555310 | ||
| B | 131071 | 18.4% |
| S | 10564 | 1.5% |
| C | 10564 | 1.5% |
| H | 6417 | 0.9% |
| F | 44 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 555310 | |
| Uppercase Letter | 158660 | 22.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| B | 131071 | |
| S | 10564 | 6.7% |
| C | 10564 | 6.7% |
| H | 6417 | 4.0% |
| F | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 555310 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 555310 | |
| Latin | 158660 | 22.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| B | 131071 | |
| S | 10564 | 6.7% |
| C | 10564 | 6.7% |
| H | 6417 | 4.0% |
| F | 44 | < 0.1% |
| Value | Count | Frequency (%) |
| 555310 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 713970 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 555310 | ||
| B | 131071 | 18.4% |
| S | 10564 | 1.5% |
| C | 10564 | 1.5% |
| H | 6417 | 0.9% |
| F | 44 | < 0.1% |
| Distinct | 166 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 24 |
| Missing (%) | < 0.1% |
| Memory size | 619.9 KiB |
| PRT | |
|---|---|
| FRA | |
| DEU | |
| GBR | |
| ESP | |
| Other values (161) |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 2.992825259 |
| Min length | 2 |
Characters and Unicode
| Total characters | 237349 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 27 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | PRT |
|---|---|
| 2nd row | PRT |
| 3rd row | PRT |
| 4th row | PRT |
| 5th row | PRT |
| Value | Count | Frequency (%) |
| PRT | 30960 | |
| FRA | 8804 | 11.1% |
| DEU | 6084 | 7.7% |
| GBR | 5315 | 6.7% |
| ESP | 4611 | 5.8% |
| ITA | 3307 | 4.2% |
| BEL | 1894 | 2.4% |
| BRA | 1794 | 2.3% |
| USA | 1618 | 2.0% |
| NLD | 1590 | 2.0% |
| Other values (156) | 13329 |
| Value | Count | Frequency (%) |
| prt | 30960 | |
| fra | 8804 | 11.1% |
| deu | 6084 | 7.7% |
| gbr | 5315 | 6.7% |
| esp | 4611 | 5.8% |
| ita | 3307 | 4.2% |
| bel | 1894 | 2.4% |
| bra | 1794 | 2.3% |
| usa | 1618 | 2.0% |
| nld | 1590 | 2.0% |
| Other values (156) | 13329 |
Most occurring characters
| Value | Count | Frequency (%) |
| R | 51360 | |
| P | 36528 | |
| T | 35836 | |
| A | 18069 | 7.6% |
| E | 15087 | 6.4% |
| U | 10706 | 4.5% |
| B | 9307 | 3.9% |
| F | 9172 | 3.9% |
| S | 8793 | 3.7% |
| D | 8323 | 3.5% |
| Other values (16) | 34168 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 237349 |
Most frequent character per category
| Value | Count | Frequency (%) |
| R | 51360 | |
| P | 36528 | |
| T | 35836 | |
| A | 18069 | 7.6% |
| E | 15087 | 6.4% |
| U | 10706 | 4.5% |
| B | 9307 | 3.9% |
| F | 9172 | 3.9% |
| S | 8793 | 3.7% |
| D | 8323 | 3.5% |
| Other values (16) | 34168 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 237349 |
Most frequent character per script
| Value | Count | Frequency (%) |
| R | 51360 | |
| P | 36528 | |
| T | 35836 | |
| A | 18069 | 7.6% |
| E | 15087 | 6.4% |
| U | 10706 | 4.5% |
| B | 9307 | 3.9% |
| F | 9172 | 3.9% |
| S | 8793 | 3.7% |
| D | 8323 | 3.5% |
| Other values (16) | 34168 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 237349 |
Most frequent character per block
| Value | Count | Frequency (%) |
| R | 51360 | |
| P | 36528 | |
| T | 35836 | |
| A | 18069 | 7.6% |
| E | 15087 | 6.4% |
| U | 10706 | 4.5% |
| B | 9307 | 3.9% |
| F | 9172 | 3.9% |
| S | 8793 | 3.7% |
| D | 8323 | 3.5% |
| Other values (16) | 34168 |
MarketSegment
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| Online TA | |
|---|---|
| Offline TA/TO | |
| Groups | |
| Direct | |
| Corporate | 2986 |
| Other values (3) | 781 |
Length
| Max length | 13 |
|---|---|
| Median length | 9 |
| Mean length | 9.109857557 |
| Min length | 6 |
Characters and Unicode
| Total characters | 722685 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Offline TA/TO |
|---|---|
| 2nd row | Online TA |
| 3rd row | Online TA |
| 4th row | Online TA |
| 5th row | Online TA |
| Value | Count | Frequency (%) |
| Online TA | 38748 | |
| Offline TA/TO | 16747 | |
| Groups | 13975 | 17.6% |
| Direct | 6093 | 7.7% |
| Corporate | 2986 | 3.8% |
| Complementary | 542 | 0.7% |
| Aviation | 237 | 0.3% |
| Undefined | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| ta | 38748 | |
| online | 38748 | |
| offline | 16747 | |
| ta/to | 16747 | |
| groups | 13975 | 10.4% |
| direct | 6093 | 4.5% |
| corporate | 2986 | 2.2% |
| complementary | 542 | 0.4% |
| aviation | 237 | 0.2% |
| undefined | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 95026 | |
| O | 72242 | |
| T | 72242 | |
| e | 65662 | |
| i | 62064 | |
| l | 56037 | |
| A | 55732 | |
| 55495 | ||
| f | 33496 | 4.6% |
| r | 26582 | 3.7% |
| Other values (16) | 128107 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 426629 | |
| Uppercase Letter | 223814 | |
| Space Separator | 55495 | 7.7% |
| Other Punctuation | 16747 | 2.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 95026 | |
| e | 65662 | |
| i | 62064 | |
| l | 56037 | |
| f | 33496 | 7.9% |
| r | 26582 | 6.2% |
| o | 20726 | 4.9% |
| p | 17503 | 4.1% |
| u | 13975 | 3.3% |
| s | 13975 | 3.3% |
| Other values (7) | 21583 | 5.1% |
| Value | Count | Frequency (%) |
| O | 72242 | |
| T | 72242 | |
| A | 55732 | |
| G | 13975 | 6.2% |
| D | 6093 | 2.7% |
| C | 3528 | 1.6% |
| U | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 55495 |
| Value | Count | Frequency (%) |
| / | 16747 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 650443 | |
| Common | 72242 | 10.0% |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 95026 | |
| O | 72242 | |
| T | 72242 | |
| e | 65662 | |
| i | 62064 | |
| l | 56037 | |
| A | 55732 | |
| f | 33496 | 5.1% |
| r | 26582 | 4.1% |
| o | 20726 | 3.2% |
| Other values (14) | 90634 |
| Value | Count | Frequency (%) |
| 55495 | ||
| / | 16747 | 23.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 722685 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 95026 | |
| O | 72242 | |
| T | 72242 | |
| e | 65662 | |
| i | 62064 | |
| l | 56037 | |
| A | 55732 | |
| 55495 | ||
| f | 33496 | 4.6% |
| r | 26582 | 3.7% |
| Other values (16) | 128107 |
DistributionChannel
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| TA/TO | |
|---|---|
| Direct | 6780 |
| Corporate | 3408 |
| GDS | 193 |
| Undefined | 4 |
Length
| Max length | 9 |
|---|---|
| Median length | 5 |
| Mean length | 5.252640867 |
| Min length | 3 |
Characters and Unicode
| Total characters | 416692 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | TA/TO |
|---|---|
| 2nd row | TA/TO |
| 3rd row | TA/TO |
| 4th row | TA/TO |
| 5th row | TA/TO |
| Value | Count | Frequency (%) |
| TA/TO | 68945 | |
| Direct | 6780 | 8.5% |
| Corporate | 3408 | 4.3% |
| GDS | 193 | 0.2% |
| Undefined | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| ta/to | 68945 | |
| direct | 6780 | 8.5% |
| corporate | 3408 | 4.3% |
| gds | 193 | 0.2% |
| undefined | 4 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| T | 137890 | |
| A | 68945 | |
| / | 68945 | |
| O | 68945 | |
| r | 13596 | 3.3% |
| e | 10196 | 2.4% |
| t | 10188 | 2.4% |
| D | 6973 | 1.7% |
| o | 6816 | 1.6% |
| i | 6784 | 1.6% |
| Other values (10) | 17414 | 4.2% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 286551 | |
| Other Punctuation | 68945 | 16.5% |
| Lowercase Letter | 61196 | 14.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| r | 13596 | |
| e | 10196 | |
| t | 10188 | |
| o | 6816 | |
| i | 6784 | |
| c | 6780 | |
| p | 3408 | 5.6% |
| a | 3408 | 5.6% |
| n | 8 | < 0.1% |
| d | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| T | 137890 | |
| A | 68945 | |
| O | 68945 | |
| D | 6973 | 2.4% |
| C | 3408 | 1.2% |
| G | 193 | 0.1% |
| S | 193 | 0.1% |
| U | 4 | < 0.1% |
| Value | Count | Frequency (%) |
| / | 68945 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 347747 | |
| Common | 68945 | 16.5% |
Most frequent character per script
| Value | Count | Frequency (%) |
| T | 137890 | |
| A | 68945 | |
| O | 68945 | |
| r | 13596 | 3.9% |
| e | 10196 | 2.9% |
| t | 10188 | 2.9% |
| D | 6973 | 2.0% |
| o | 6816 | 2.0% |
| i | 6784 | 2.0% |
| c | 6780 | 1.9% |
| Other values (9) | 10634 | 3.1% |
| Value | Count | Frequency (%) |
| / | 68945 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 416692 |
Most frequent character per block
| Value | Count | Frequency (%) |
| T | 137890 | |
| A | 68945 | |
| / | 68945 | |
| O | 68945 | |
| r | 13596 | 3.3% |
| e | 10196 | 2.4% |
| t | 10188 | 2.4% |
| D | 6973 | 1.7% |
| o | 6816 | 1.6% |
| i | 6784 | 1.6% |
| Other values (10) | 17414 | 4.2% |
IsRepeatedGuest
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 0 | |
|---|---|
| 1 | 2032 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 79330 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79330 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79330 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79330 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 77298 | |
| 1 | 2032 | 2.6% |
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.07974284634 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 73941 |
| Zeros (%) | 93.2% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.4154722143 |
|---|---|
| Coefficient of variation (CV) | 5.210150294 |
| Kurtosis | 451.5578665 |
| Mean | 0.07974284634 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 16.58489813 |
| Sum | 6326 |
| Variance | 0.1726171609 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 73941 | |
| 1 | 5155 | 6.5% |
| 2 | 72 | 0.1% |
| 3 | 51 | 0.1% |
| 11 | 35 | < 0.1% |
| 4 | 25 | < 0.1% |
| 6 | 22 | < 0.1% |
| 5 | 16 | < 0.1% |
| 13 | 12 | < 0.1% |
| 21 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 73941 | |
| 1 | 5155 | 6.5% |
| 2 | 72 | 0.1% |
| 3 | 51 | 0.1% |
| 4 | 25 | < 0.1% |
| Value | Count | Frequency (%) |
| 21 | 1 | < 0.1% |
| 13 | 12 | < 0.1% |
| 11 | 35 | |
| 6 | 22 | |
| 5 | 16 |
| Distinct | 73 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.132371108 |
|---|---|
| Minimum | 0 |
| Maximum | 72 |
| Zeros | 77742 |
| Zeros (%) | 98.0% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 72 |
| Range | 72 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 1.693410601 |
|---|---|
| Coefficient of variation (CV) | 12.79290191 |
| Kurtosis | 690.7081155 |
| Mean | 0.132371108 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 23.1165642 |
| Sum | 10501 |
| Variance | 2.867639463 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 77742 | |
| 1 | 569 | 0.7% |
| 2 | 192 | 0.2% |
| 3 | 129 | 0.2% |
| 4 | 102 | 0.1% |
| 5 | 90 | 0.1% |
| 6 | 59 | 0.1% |
| 7 | 51 | 0.1% |
| 8 | 37 | < 0.1% |
| 9 | 36 | < 0.1% |
| Other values (63) | 323 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 77742 | |
| 1 | 569 | 0.7% |
| 2 | 192 | 0.2% |
| 3 | 129 | 0.2% |
| 4 | 102 | 0.1% |
| Value | Count | Frequency (%) |
| 72 | 1 | |
| 71 | 1 | |
| 70 | 1 | |
| 69 | 1 | |
| 68 | 1 |
ReservedRoomType
Categorical
| Distinct | 8 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| A | |
|---|---|
| D | |
| F | 1791 |
| E | 1553 |
| B | 1115 |
| Other values (3) | 508 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 1269280 |
|---|---|
| Distinct characters | 9 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
| Value | Count | Frequency (%) |
| A | 62595 | |
| D | 11768 | 14.8% |
| F | 1791 | 2.3% |
| E | 1553 | 2.0% |
| B | 1115 | 1.4% |
| G | 484 | 0.6% |
| C | 14 | < 0.1% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| a | 62595 | |
| d | 11768 | 14.8% |
| f | 1791 | 2.3% |
| e | 1553 | 2.0% |
| b | 1115 | 1.4% |
| g | 484 | 0.6% |
| c | 14 | < 0.1% |
| p | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1189950 | ||
| A | 62595 | 4.9% |
| D | 11768 | 0.9% |
| F | 1791 | 0.1% |
| E | 1553 | 0.1% |
| B | 1115 | 0.1% |
| G | 484 | < 0.1% |
| C | 14 | < 0.1% |
| P | 10 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 1189950 | |
| Uppercase Letter | 79330 | 6.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 62595 | |
| D | 11768 | 14.8% |
| F | 1791 | 2.3% |
| E | 1553 | 2.0% |
| B | 1115 | 1.4% |
| G | 484 | 0.6% |
| C | 14 | < 0.1% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 1189950 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1189950 | |
| Latin | 79330 | 6.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 62595 | |
| D | 11768 | 14.8% |
| F | 1791 | 2.3% |
| E | 1553 | 2.0% |
| B | 1115 | 1.4% |
| G | 484 | 0.6% |
| C | 14 | < 0.1% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 1189950 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1269280 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1189950 | ||
| A | 62595 | 4.9% |
| D | 11768 | 0.9% |
| F | 1791 | 0.1% |
| E | 1553 | 0.1% |
| B | 1115 | 0.1% |
| G | 484 | < 0.1% |
| C | 14 | < 0.1% |
| P | 10 | < 0.1% |
AssignedRoomType
Categorical
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| A | |
|---|---|
| D | |
| E | 2168 |
| F | 2018 |
| B | 2004 |
| Other values (4) | 1150 |
Length
| Max length | 16 |
|---|---|
| Median length | 16 |
| Mean length | 16 |
| Min length | 16 |
Characters and Unicode
| Total characters | 1269280 |
|---|---|
| Distinct characters | 10 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
| Value | Count | Frequency (%) |
| A | 57007 | |
| D | 14983 | 18.9% |
| E | 2168 | 2.7% |
| F | 2018 | 2.5% |
| B | 2004 | 2.5% |
| G | 700 | 0.9% |
| K | 279 | 0.4% |
| C | 161 | 0.2% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| a | 57007 | |
| d | 14983 | 18.9% |
| e | 2168 | 2.7% |
| f | 2018 | 2.5% |
| b | 2004 | 2.5% |
| g | 700 | 0.9% |
| k | 279 | 0.4% |
| c | 161 | 0.2% |
| p | 10 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1189950 | ||
| A | 57007 | 4.5% |
| D | 14983 | 1.2% |
| E | 2168 | 0.2% |
| F | 2018 | 0.2% |
| B | 2004 | 0.2% |
| G | 700 | 0.1% |
| K | 279 | < 0.1% |
| C | 161 | < 0.1% |
| P | 10 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 1189950 | |
| Uppercase Letter | 79330 | 6.2% |
Most frequent character per category
| Value | Count | Frequency (%) |
| A | 57007 | |
| D | 14983 | 18.9% |
| E | 2168 | 2.7% |
| F | 2018 | 2.5% |
| B | 2004 | 2.5% |
| G | 700 | 0.9% |
| K | 279 | 0.4% |
| C | 161 | 0.2% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 1189950 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1189950 | |
| Latin | 79330 | 6.2% |
Most frequent character per script
| Value | Count | Frequency (%) |
| A | 57007 | |
| D | 14983 | 18.9% |
| E | 2168 | 2.7% |
| F | 2018 | 2.5% |
| B | 2004 | 2.5% |
| G | 700 | 0.9% |
| K | 279 | 0.4% |
| C | 161 | 0.2% |
| P | 10 | < 0.1% |
| Value | Count | Frequency (%) |
| 1189950 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1269280 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 1189950 | ||
| A | 57007 | 4.5% |
| D | 14983 | 1.2% |
| E | 2168 | 0.2% |
| F | 2018 | 0.2% |
| B | 2004 | 0.2% |
| G | 700 | 0.1% |
| K | 279 | < 0.1% |
| C | 161 | < 0.1% |
| P | 10 | < 0.1% |
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.1873692172 |
|---|---|
| Minimum | 0 |
| Maximum | 21 |
| Zeros | 69062 |
| Zeros (%) | 87.1% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 1 |
| Maximum | 21 |
| Range | 21 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 0.6086203136 |
|---|---|
| Coefficient of variation (CV) | 3.248240681 |
| Kurtosis | 118.5593153 |
| Mean | 0.1873692172 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 7.245915202 |
| Sum | 14864 |
| Variance | 0.3704186862 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 69062 | |
| 1 | 7232 | 9.1% |
| 2 | 2244 | 2.8% |
| 3 | 467 | 0.6% |
| 4 | 194 | 0.2% |
| 5 | 46 | 0.1% |
| 6 | 31 | < 0.1% |
| 7 | 19 | < 0.1% |
| 8 | 9 | < 0.1% |
| 14 | 5 | < 0.1% |
| Other values (11) | 21 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 69062 | |
| 1 | 7232 | 9.1% |
| 2 | 2244 | 2.8% |
| 3 | 467 | 0.6% |
| 4 | 194 | 0.2% |
| Value | Count | Frequency (%) |
| 21 | 1 | |
| 20 | 1 | |
| 18 | 1 | |
| 17 | 1 | |
| 16 | 1 |
DepositType
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| No Deposit | |
|---|---|
| Non Refund | |
| Refundable | 20 |
Length
| Max length | 15 |
|---|---|
| Median length | 15 |
| Mean length | 15 |
| Min length | 15 |
Characters and Unicode
| Total characters | 1189950 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | No Deposit |
|---|---|
| 2nd row | No Deposit |
| 3rd row | No Deposit |
| 4th row | No Deposit |
| 5th row | No Deposit |
| Value | Count | Frequency (%) |
| No Deposit | 66442 | |
| Non Refund | 12868 | 16.2% |
| Refundable | 20 | < 0.1% |
| Value | Count | Frequency (%) |
| deposit | 66442 | |
| no | 66442 | |
| non | 12868 | 8.1% |
| refund | 12868 | 8.1% |
| refundable | 20 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 475960 | ||
| o | 145752 | 12.2% |
| e | 79350 | 6.7% |
| N | 79310 | 6.7% |
| D | 66442 | 5.6% |
| p | 66442 | 5.6% |
| s | 66442 | 5.6% |
| i | 66442 | 5.6% |
| t | 66442 | 5.6% |
| n | 25756 | 2.2% |
| Other values (7) | 51612 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 555350 | |
| Space Separator | 475960 | |
| Uppercase Letter | 158640 | 13.3% |
Most frequent character per category
| Value | Count | Frequency (%) |
| o | 145752 | |
| e | 79350 | |
| p | 66442 | |
| s | 66442 | |
| i | 66442 | |
| t | 66442 | |
| n | 25756 | 4.6% |
| f | 12888 | 2.3% |
| u | 12888 | 2.3% |
| d | 12888 | 2.3% |
| Other values (3) | 60 | < 0.1% |
| Value | Count | Frequency (%) |
| N | 79310 | |
| D | 66442 | |
| R | 12888 | 8.1% |
| Value | Count | Frequency (%) |
| 475960 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 713990 | |
| Common | 475960 |
Most frequent character per script
| Value | Count | Frequency (%) |
| o | 145752 | |
| e | 79350 | |
| N | 79310 | |
| D | 66442 | |
| p | 66442 | |
| s | 66442 | |
| i | 66442 | |
| t | 66442 | |
| n | 25756 | 3.6% |
| R | 12888 | 1.8% |
| Other values (6) | 38724 | 5.4% |
| Value | Count | Frequency (%) |
| 475960 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1189950 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 475960 | ||
| o | 145752 | 12.2% |
| e | 79350 | 6.7% |
| N | 79310 | 6.7% |
| D | 66442 | 5.6% |
| p | 66442 | 5.6% |
| s | 66442 | 5.6% |
| i | 66442 | 5.6% |
| t | 66442 | 5.6% |
| n | 25756 | 2.2% |
| Other values (7) | 51612 | 4.3% |
| Distinct | 224 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 9 | |
|---|---|
| NULL | |
| 1 | |
| 14 | |
| 7 | |
| Other values (219) |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 872630 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 38 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 6 |
|---|---|
| 2nd row | 9 |
| 3rd row | 9 |
| 4th row | 9 |
| 5th row | 9 |
| Value | Count | Frequency (%) |
| 9 | 31955 | |
| NULL | 8131 | 10.2% |
| 1 | 7137 | 9.0% |
| 14 | 3640 | 4.6% |
| 7 | 3539 | 4.5% |
| 6 | 2683 | 3.4% |
| 28 | 1666 | 2.1% |
| 3 | 1308 | 1.6% |
| 8 | 1236 | 1.6% |
| 37 | 1230 | 1.6% |
| Other values (214) | 16805 |
| Value | Count | Frequency (%) |
| 9 | 31955 | |
| null | 8131 | 10.2% |
| 1 | 7137 | 9.0% |
| 14 | 3640 | 4.6% |
| 7 | 3539 | 4.5% |
| 6 | 2683 | 3.4% |
| 28 | 1666 | 2.1% |
| 3 | 1308 | 1.6% |
| 8 | 1236 | 1.6% |
| 37 | 1230 | 1.6% |
| Other values (214) | 16805 |
Most occurring characters
| Value | Count | Frequency (%) |
| 740620 | ||
| 9 | 36250 | 4.2% |
| 1 | 19113 | 2.2% |
| L | 16262 | 1.9% |
| 2 | 9607 | 1.1% |
| N | 8131 | 0.9% |
| U | 8131 | 0.9% |
| 3 | 6509 | 0.7% |
| 7 | 6396 | 0.7% |
| 4 | 6022 | 0.7% |
| Other values (4) | 15589 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 740620 | |
| Decimal Number | 99486 | 11.4% |
| Uppercase Letter | 32524 | 3.7% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 9 | 36250 | |
| 1 | 19113 | |
| 2 | 9607 | 9.7% |
| 3 | 6509 | 6.5% |
| 7 | 6396 | 6.4% |
| 4 | 6022 | 6.1% |
| 8 | 5978 | 6.0% |
| 6 | 4811 | 4.8% |
| 5 | 2996 | 3.0% |
| 0 | 1804 | 1.8% |
| Value | Count | Frequency (%) |
| L | 16262 | |
| N | 8131 | |
| U | 8131 |
| Value | Count | Frequency (%) |
| 740620 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 840106 | |
| Latin | 32524 | 3.7% |
Most frequent character per script
| Value | Count | Frequency (%) |
| 740620 | ||
| 9 | 36250 | 4.3% |
| 1 | 19113 | 2.3% |
| 2 | 9607 | 1.1% |
| 3 | 6509 | 0.8% |
| 7 | 6396 | 0.8% |
| 4 | 6022 | 0.7% |
| 8 | 5978 | 0.7% |
| 6 | 4811 | 0.6% |
| 5 | 2996 | 0.4% |
| Value | Count | Frequency (%) |
| L | 16262 | |
| N | 8131 | |
| U | 8131 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 872630 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 740620 | ||
| 9 | 36250 | 4.2% |
| 1 | 19113 | 2.2% |
| L | 16262 | 1.9% |
| 2 | 9607 | 1.1% |
| N | 8131 | 0.9% |
| U | 8131 | 0.9% |
| 3 | 6509 | 0.7% |
| 7 | 6396 | 0.7% |
| 4 | 6022 | 0.7% |
| Other values (4) | 15589 | 1.8% |
| Distinct | 208 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| NULL | |
|---|---|
| 40 | 924 |
| 67 | 267 |
| 45 | 250 |
| 153 | 215 |
| Other values (203) | 2033 |
Length
| Max length | 11 |
|---|---|
| Median length | 11 |
| Mean length | 11 |
| Min length | 11 |
Characters and Unicode
| Total characters | 872630 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 74 ? |
|---|---|
| Unique (%) | 0.1% |
Sample
| 1st row | NULL |
|---|---|
| 2nd row | NULL |
| 3rd row | NULL |
| 4th row | NULL |
| 5th row | NULL |
| Value | Count | Frequency (%) |
| NULL | 75641 | |
| 40 | 924 | 1.2% |
| 67 | 267 | 0.3% |
| 45 | 250 | 0.3% |
| 153 | 215 | 0.3% |
| 219 | 141 | 0.2% |
| 233 | 114 | 0.1% |
| 174 | 113 | 0.1% |
| 51 | 86 | 0.1% |
| 242 | 61 | 0.1% |
| Other values (198) | 1518 | 1.9% |
| Value | Count | Frequency (%) |
| null | 75641 | |
| 40 | 924 | 1.2% |
| 67 | 267 | 0.3% |
| 45 | 250 | 0.3% |
| 153 | 215 | 0.3% |
| 219 | 141 | 0.2% |
| 233 | 114 | 0.1% |
| 174 | 113 | 0.1% |
| 51 | 86 | 0.1% |
| 242 | 61 | 0.1% |
| Other values (198) | 1518 | 1.9% |
Most occurring characters
| Value | Count | Frequency (%) |
| 560896 | ||
| L | 151282 | 17.3% |
| N | 75641 | 8.7% |
| U | 75641 | 8.7% |
| 4 | 1844 | 0.2% |
| 0 | 1216 | 0.1% |
| 1 | 1154 | 0.1% |
| 2 | 1016 | 0.1% |
| 3 | 973 | 0.1% |
| 5 | 769 | 0.1% |
| Other values (4) | 2198 | 0.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Space Separator | 560896 | |
| Uppercase Letter | 302564 | |
| Decimal Number | 9170 | 1.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 4 | 1844 | |
| 0 | 1216 | |
| 1 | 1154 | |
| 2 | 1016 | |
| 3 | 973 | |
| 5 | 769 | |
| 7 | 657 | 7.2% |
| 6 | 600 | 6.5% |
| 8 | 503 | 5.5% |
| 9 | 438 | 4.8% |
| Value | Count | Frequency (%) |
| L | 151282 | |
| N | 75641 | |
| U | 75641 |
| Value | Count | Frequency (%) |
| 560896 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 570066 | |
| Latin | 302564 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 560896 | ||
| 4 | 1844 | 0.3% |
| 0 | 1216 | 0.2% |
| 1 | 1154 | 0.2% |
| 2 | 1016 | 0.2% |
| 3 | 973 | 0.2% |
| 5 | 769 | 0.1% |
| 7 | 657 | 0.1% |
| 6 | 600 | 0.1% |
| 8 | 503 | 0.1% |
| Value | Count | Frequency (%) |
| L | 151282 | |
| N | 75641 | |
| U | 75641 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 872630 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 560896 | ||
| L | 151282 | 17.3% |
| N | 75641 | 8.7% |
| U | 75641 | 8.7% |
| 4 | 1844 | 0.2% |
| 0 | 1216 | 0.1% |
| 1 | 1154 | 0.1% |
| 2 | 1016 | 0.1% |
| 3 | 973 | 0.1% |
| 5 | 769 | 0.1% |
| Other values (4) | 2198 | 0.3% |
| Distinct | 115 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.226774234 |
|---|---|
| Minimum | 0 |
| Maximum | 391 |
| Zeros | 75887 |
| Zeros (%) | 95.7% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 391 |
| Range | 391 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 20.87089 |
|---|---|
| Coefficient of variation (CV) | 6.468035407 |
| Kurtosis | 137.5299571 |
| Mean | 3.226774234 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 10.30524112 |
| Sum | 255980 |
| Variance | 435.5940492 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 75887 | |
| 39 | 226 | 0.3% |
| 58 | 164 | 0.2% |
| 44 | 140 | 0.2% |
| 31 | 127 | 0.2% |
| 35 | 96 | 0.1% |
| 46 | 94 | 0.1% |
| 69 | 89 | 0.1% |
| 63 | 83 | 0.1% |
| 87 | 80 | 0.1% |
| Other values (105) | 2344 | 3.0% |
| Value | Count | Frequency (%) |
| 0 | 75887 | |
| 1 | 7 | < 0.1% |
| 2 | 3 | < 0.1% |
| 3 | 59 | 0.1% |
| 4 | 22 | < 0.1% |
| Value | Count | Frequency (%) |
| 391 | 45 | |
| 379 | 15 | < 0.1% |
| 330 | 15 | < 0.1% |
| 259 | 10 | < 0.1% |
| 236 | 35 |
CustomerType
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| Transient | |
|---|---|
| Transient-Party | |
| Contract | 2300 |
| Group | 293 |
Length
| Max length | 15 |
|---|---|
| Median length | 9 |
| Mean length | 10.2671877 |
| Min length | 5 |
Characters and Unicode
| Total characters | 814496 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Transient |
|---|---|
| 2nd row | Transient |
| 3rd row | Transient |
| 4th row | Transient |
| 5th row | Transient |
| Value | Count | Frequency (%) |
| Transient | 59404 | |
| Transient-Party | 17333 | 21.8% |
| Contract | 2300 | 2.9% |
| Group | 293 | 0.4% |
| Value | Count | Frequency (%) |
| transient | 59404 | |
| transient-party | 17333 | 21.8% |
| contract | 2300 | 2.9% |
| group | 293 | 0.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| n | 155774 | |
| t | 98670 | |
| r | 96663 | |
| a | 96370 | |
| T | 76737 | |
| s | 76737 | |
| i | 76737 | |
| e | 76737 | |
| - | 17333 | 2.1% |
| P | 17333 | 2.1% |
| Other values (7) | 25405 | 3.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 700500 | |
| Uppercase Letter | 96663 | 11.9% |
| Dash Punctuation | 17333 | 2.1% |
Most frequent character per category
| Value | Count | Frequency (%) |
| n | 155774 | |
| t | 98670 | |
| r | 96663 | |
| a | 96370 | |
| s | 76737 | |
| i | 76737 | |
| e | 76737 | |
| y | 17333 | 2.5% |
| o | 2593 | 0.4% |
| c | 2300 | 0.3% |
| Other values (2) | 586 | 0.1% |
| Value | Count | Frequency (%) |
| T | 76737 | |
| P | 17333 | 17.9% |
| C | 2300 | 2.4% |
| G | 293 | 0.3% |
| Value | Count | Frequency (%) |
| - | 17333 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 797163 | |
| Common | 17333 | 2.1% |
Most frequent character per script
| Value | Count | Frequency (%) |
| n | 155774 | |
| t | 98670 | |
| r | 96663 | |
| a | 96370 | |
| T | 76737 | |
| s | 76737 | |
| i | 76737 | |
| e | 76737 | |
| P | 17333 | 2.2% |
| y | 17333 | 2.2% |
| Other values (6) | 8072 | 1.0% |
| Value | Count | Frequency (%) |
| - | 17333 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 814496 |
Most frequent character per block
| Value | Count | Frequency (%) |
| n | 155774 | |
| t | 98670 | |
| r | 96663 | |
| a | 96370 | |
| T | 76737 | |
| s | 76737 | |
| i | 76737 | |
| e | 76737 | |
| - | 17333 | 2.1% |
| P | 17333 | 2.1% |
| Other values (7) | 25405 | 3.1% |
| Distinct | 5405 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 105.3044654 |
|---|---|
| Minimum | 0 |
| Maximum | 5400 |
| Zeros | 1208 |
| Zeros (%) | 1.5% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 62 |
| Q1 | 79.2 |
| median | 99.9 |
| Q3 | 126 |
| 95-th percentile | 175.5 |
| Maximum | 5400 |
| Range | 5400 |
| Interquartile range (IQR) | 46.8 |
Descriptive statistics
| Standard deviation | 43.60295384 |
|---|---|
| Coefficient of variation (CV) | 0.4140655733 |
| Kurtosis | 2741.52335 |
| Mean | 105.3044654 |
| Median Absolute Deviation (MAD) | 23.32 |
| Skewness | 23.16174514 |
| Sum | 8353803.24 |
| Variance | 1901.217583 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 62 | 3593 | 4.5% |
| 75 | 2372 | 3.0% |
| 90 | 2208 | 2.8% |
| 65 | 2057 | 2.6% |
| 95 | 1501 | 1.9% |
| 120 | 1458 | 1.8% |
| 80 | 1426 | 1.8% |
| 100 | 1422 | 1.8% |
| 110 | 1382 | 1.7% |
| 130 | 1222 | 1.5% |
| Other values (5395) | 60689 |
| Value | Count | Frequency (%) |
| 0 | 1208 | |
| 0.5 | 1 | < 0.1% |
| 1 | 15 | < 0.1% |
| 1.29 | 1 | < 0.1% |
| 1.48 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 5400 | 1 | |
| 510 | 1 | |
| 451.5 | 1 | |
| 375.5 | 1 | |
| 372.33 | 1 |
RequiredCarParkingSpaces
Categorical
| Distinct | 4 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 0 | |
|---|---|
| 1 | 1921 |
| 2 | 3 |
| 3 | 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 79330 |
|---|---|
| Distinct characters | 4 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 79330 |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 79330 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 79330 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 77404 | |
| 1 | 1921 | 2.4% |
| 2 | 3 | < 0.1% |
| 3 | 2 | < 0.1% |
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.5469179377 |
|---|---|
| Minimum | 0 |
| Maximum | 5 |
| Zeros | 47957 |
| Zeros (%) | 60.5% |
| Memory size | 619.9 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 1 |
| 95-th percentile | 2 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.7807762224 |
|---|---|
| Coefficient of variation (CV) | 1.427593005 |
| Kurtosis | 1.658703225 |
| Mean | 0.5469179377 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 1.403768024 |
| Sum | 43387 |
| Variance | 0.6096115095 |
| Monotocity | Not monotonic |
| Value | Count | Frequency (%) |
| 0 | 47957 | |
| 1 | 21420 | |
| 2 | 8142 | 10.3% |
| 3 | 1587 | 2.0% |
| 4 | 198 | 0.2% |
| 5 | 26 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 47957 | |
| 1 | 21420 | |
| 2 | 8142 | 10.3% |
| 3 | 1587 | 2.0% |
| 4 | 198 | 0.2% |
| Value | Count | Frequency (%) |
| 5 | 26 | < 0.1% |
| 4 | 198 | 0.2% |
| 3 | 1587 | 2.0% |
| 2 | 8142 | 10.3% |
| 1 | 21420 |
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| Check-Out | |
|---|---|
| Canceled | |
| No-Show | 916 |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 8.571183663 |
| Min length | 7 |
Characters and Unicode
| Total characters | 679952 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Check-Out |
|---|---|
| 2nd row | Canceled |
| 3rd row | Canceled |
| 4th row | Canceled |
| 5th row | Canceled |
| Value | Count | Frequency (%) |
| Check-Out | 46228 | |
| Canceled | 32186 | |
| No-Show | 916 | 1.2% |
| Value | Count | Frequency (%) |
| check-out | 46228 | |
| canceled | 32186 | |
| no-show | 916 | 1.2% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 110600 | |
| C | 78414 | |
| c | 78414 | |
| h | 47144 | |
| - | 47144 | |
| k | 46228 | |
| O | 46228 | |
| u | 46228 | |
| t | 46228 | |
| a | 32186 | 4.7% |
| Other values (7) | 101138 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 506334 | |
| Uppercase Letter | 126474 | 18.6% |
| Dash Punctuation | 47144 | 6.9% |
Most frequent character per category
| Value | Count | Frequency (%) |
| e | 110600 | |
| c | 78414 | |
| h | 47144 | |
| k | 46228 | |
| u | 46228 | |
| t | 46228 | |
| a | 32186 | 6.4% |
| n | 32186 | 6.4% |
| l | 32186 | 6.4% |
| d | 32186 | 6.4% |
| Other values (2) | 2748 | 0.5% |
| Value | Count | Frequency (%) |
| C | 78414 | |
| O | 46228 | |
| N | 916 | 0.7% |
| S | 916 | 0.7% |
| Value | Count | Frequency (%) |
| - | 47144 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 632808 | |
| Common | 47144 | 6.9% |
Most frequent character per script
| Value | Count | Frequency (%) |
| e | 110600 | |
| C | 78414 | |
| c | 78414 | |
| h | 47144 | |
| k | 46228 | |
| O | 46228 | |
| u | 46228 | |
| t | 46228 | |
| a | 32186 | 5.1% |
| n | 32186 | 5.1% |
| Other values (6) | 68952 |
| Value | Count | Frequency (%) |
| - | 47144 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 679952 |
Most frequent character per block
| Value | Count | Frequency (%) |
| e | 110600 | |
| C | 78414 | |
| c | 78414 | |
| h | 47144 | |
| - | 47144 | |
| k | 46228 | |
| O | 46228 | |
| u | 46228 | |
| t | 46228 | |
| a | 32186 | 4.7% |
| Other values (7) | 101138 |
| Distinct | 864 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 619.9 KiB |
| 2015-10-21 | 1416 |
|---|---|
| 2015-07-06 | 763 |
| 2015-01-01 | 760 |
| 2016-11-25 | 746 |
| 2016-01-18 | 553 |
| Other values (859) |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 793300 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
Unique
| Unique | 19 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 2015-07-03 |
|---|---|
| 2nd row | 2015-07-01 |
| 3rd row | 2015-04-30 |
| 4th row | 2015-06-23 |
| 5th row | 2015-04-02 |
| Value | Count | Frequency (%) |
| 2015-10-21 | 1416 | 1.8% |
| 2015-07-06 | 763 | 1.0% |
| 2015-01-01 | 760 | 1.0% |
| 2016-11-25 | 746 | 0.9% |
| 2016-01-18 | 553 | 0.7% |
| 2015-07-02 | 455 | 0.6% |
| 2015-12-18 | 402 | 0.5% |
| 2016-12-07 | 392 | 0.5% |
| 2017-01-24 | 290 | 0.4% |
| 2016-03-15 | 285 | 0.4% |
| Other values (854) | 73268 |
| Value | Count | Frequency (%) |
| 2015-10-21 | 1416 | 1.8% |
| 2015-07-06 | 763 | 1.0% |
| 2015-01-01 | 760 | 1.0% |
| 2016-11-25 | 746 | 0.9% |
| 2016-01-18 | 553 | 0.7% |
| 2015-07-02 | 455 | 0.6% |
| 2015-12-18 | 402 | 0.5% |
| 2016-12-07 | 392 | 0.5% |
| 2017-01-24 | 290 | 0.4% |
| 2016-03-15 | 285 | 0.4% |
| Other values (854) | 73268 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 179738 | |
| - | 158660 | |
| 1 | 145481 | |
| 2 | 125032 | |
| 6 | 53094 | 6.7% |
| 7 | 39878 | 5.0% |
| 5 | 30746 | 3.9% |
| 3 | 17346 | 2.2% |
| 8 | 15153 | 1.9% |
| 9 | 14267 | 1.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 634640 | |
| Dash Punctuation | 158660 | 20.0% |
Most frequent character per category
| Value | Count | Frequency (%) |
| 0 | 179738 | |
| 1 | 145481 | |
| 2 | 125032 | |
| 6 | 53094 | 8.4% |
| 7 | 39878 | 6.3% |
| 5 | 30746 | 4.8% |
| 3 | 17346 | 2.7% |
| 8 | 15153 | 2.4% |
| 9 | 14267 | 2.2% |
| 4 | 13905 | 2.2% |
| Value | Count | Frequency (%) |
| - | 158660 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 793300 |
Most frequent character per script
| Value | Count | Frequency (%) |
| 0 | 179738 | |
| - | 158660 | |
| 1 | 145481 | |
| 2 | 125032 | |
| 6 | 53094 | 6.7% |
| 7 | 39878 | 5.0% |
| 5 | 30746 | 3.9% |
| 3 | 17346 | 2.2% |
| 8 | 15153 | 1.9% |
| 9 | 14267 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 793300 |
Most frequent character per block
| Value | Count | Frequency (%) |
| 0 | 179738 | |
| - | 158660 | |
| 1 | 145481 | |
| 2 | 125032 | |
| 6 | 53094 | 6.7% |
| 7 | 39878 | 5.0% |
| 5 | 30746 | 3.9% |
| 3 | 17346 | 2.2% |
| 8 | 15153 | 1.9% |
| 9 | 14267 | 1.8% |
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 0 | 6 | 2015 | July | 27 | 1 | 0 | 2 | 1 | 0.0 | 0 | HB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 6 | NULL | 0 | Transient | 0.00 | 0 | 0 | Check-Out | 2015-07-03 |
| 1 | 1 | 88 | 2015 | July | 27 | 1 | 0 | 4 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 76.50 | 0 | 1 | Canceled | 2015-07-01 |
| 2 | 1 | 65 | 2015 | July | 27 | 1 | 0 | 4 | 1 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 68.00 | 0 | 1 | Canceled | 2015-04-30 |
| 3 | 1 | 92 | 2015 | July | 27 | 1 | 2 | 4 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 76.50 | 0 | 2 | Canceled | 2015-06-23 |
| 4 | 1 | 100 | 2015 | July | 27 | 2 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 76.50 | 0 | 1 | Canceled | 2015-04-02 |
| 5 | 1 | 79 | 2015 | July | 27 | 2 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 76.50 | 0 | 1 | Canceled | 2015-06-25 |
| 6 | 0 | 3 | 2015 | July | 27 | 2 | 0 | 3 | 1 | 0.0 | 0 | HB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 1 | No Deposit | 1 | NULL | 0 | Transient-Party | 58.67 | 0 | 0 | Check-Out | 2015-07-05 |
| 7 | 1 | 63 | 2015 | July | 27 | 2 | 1 | 3 | 1 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 68.00 | 0 | 0 | Canceled | 2015-06-25 |
| 8 | 1 | 62 | 2015 | July | 27 | 2 | 2 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 8 | NULL | 0 | Transient | 76.50 | 0 | 1 | No-Show | 2015-07-02 |
| 9 | 1 | 62 | 2015 | July | 27 | 2 | 2 | 3 | 2 | 0.0 | 0 | BB | PRT | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 8 | NULL | 0 | Transient | 76.50 | 0 | 1 | No-Show | 2015-07-02 |
Last rows
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79320 | 0 | 44 | 2017 | August | 35 | 31 | 1 | 3 | 2 | 0.0 | 0 | SC | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 140.75 | 0 | 1 | Check-Out | 2017-09-04 |
| 79321 | 0 | 188 | 2017 | August | 35 | 31 | 2 | 3 | 2 | 0.0 | 0 | BB | DEU | Direct | Direct | 0 | 0 | 0 | A | A | 0 | No Deposit | 14 | NULL | 0 | Transient | 99.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 79322 | 0 | 135 | 2017 | August | 35 | 30 | 2 | 4 | 3 | 0.0 | 0 | BB | JPN | Online TA | TA/TO | 0 | 0 | 0 | G | G | 0 | No Deposit | 7 | NULL | 0 | Transient | 209.00 | 0 | 0 | Check-Out | 2017-09-05 |
| 79323 | 0 | 164 | 2017 | August | 35 | 31 | 2 | 4 | 2 | 0.0 | 0 | BB | DEU | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 42 | NULL | 0 | Transient | 87.60 | 0 | 0 | Check-Out | 2017-09-06 |
| 79324 | 0 | 21 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394 | NULL | 0 | Transient | 96.14 | 0 | 2 | Check-Out | 2017-09-06 |
| 79325 | 0 | 23 | 2017 | August | 35 | 30 | 2 | 5 | 2 | 0.0 | 0 | BB | BEL | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 394 | NULL | 0 | Transient | 96.14 | 0 | 0 | Check-Out | 2017-09-06 |
| 79326 | 0 | 102 | 2017 | August | 35 | 31 | 2 | 5 | 3 | 0.0 | 0 | BB | FRA | Online TA | TA/TO | 0 | 0 | 0 | E | E | 0 | No Deposit | 9 | NULL | 0 | Transient | 225.43 | 0 | 2 | Check-Out | 2017-09-07 |
| 79327 | 0 | 34 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | DEU | Online TA | TA/TO | 0 | 0 | 0 | D | D | 0 | No Deposit | 9 | NULL | 0 | Transient | 157.71 | 0 | 4 | Check-Out | 2017-09-07 |
| 79328 | 0 | 109 | 2017 | August | 35 | 31 | 2 | 5 | 2 | 0.0 | 0 | BB | GBR | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 89 | NULL | 0 | Transient | 104.40 | 0 | 0 | Check-Out | 2017-09-07 |
| 79329 | 0 | 205 | 2017 | August | 35 | 29 | 2 | 7 | 2 | 0.0 | 0 | HB | DEU | Online TA | TA/TO | 0 | 0 | 0 | A | A | 0 | No Deposit | 9 | NULL | 0 | Transient | 151.20 | 0 | 2 | Check-Out | 2017-09-07 |
Most frequent
| IsCanceled | LeadTime | ArrivalDateYear | ArrivalDateMonth | ArrivalDateWeekNumber | ArrivalDateDayOfMonth | StaysInWeekendNights | StaysInWeekNights | Adults | Children | Babies | Meal | Country | MarketSegment | DistributionChannel | IsRepeatedGuest | PreviousCancellations | PreviousBookingsNotCanceled | ReservedRoomType | AssignedRoomType | BookingChanges | DepositType | Agent | Company | DaysInWaitingList | CustomerType | ADR | RequiredCarParkingSpaces | TotalOfSpecialRequests | ReservationStatus | ReservationStatusDate | count | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5404 | 1 | 277 | 2016 | November | 46 | 7 | 1 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NULL | NULL | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2016-04-04 | 180 |
| 4181 | 1 | 68 | 2016 | February | 8 | 17 | 0 | 2 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 37 | NULL | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2016-01-06 | 150 |
| 5075 | 1 | 188 | 2016 | June | 25 | 15 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 119 | NULL | 39 | Transient | 130.0 | 0 | 0 | Canceled | 2016-01-18 | 109 |
| 4879 | 1 | 158 | 2016 | May | 22 | 24 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37 | NULL | 31 | Transient | 130.0 | 0 | 0 | Canceled | 2016-01-18 | 101 |
| 3850 | 1 | 34 | 2015 | December | 50 | 8 | 0 | 2 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 1 | 0 | A | A | 0 | Non Refund | 19 | NULL | 0 | Transient | 90.0 | 0 | 0 | Canceled | 2015-11-17 | 100 |
| 3792 | 1 | 28 | 2017 | March | 9 | 2 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | NULL | NULL | 0 | Transient | 95.0 | 0 | 0 | Canceled | 2017-02-02 | 99 |
| 3906 | 1 | 38 | 2017 | January | 2 | 14 | 0 | 1 | 1 | 0.0 | 0 | BB | PRT | Corporate | Corporate | 0 | 0 | 0 | A | A | 0 | Non Refund | NULL | 67 | 0 | Transient | 75.0 | 0 | 0 | Canceled | 2016-12-07 | 99 |
| 4872 | 1 | 156 | 2017 | April | 17 | 26 | 0 | 3 | 2 | 0.0 | 0 | BB | PRT | Groups | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 37 | NULL | 0 | Transient | 100.0 | 0 | 0 | Canceled | 2016-11-21 | 99 |
| 4205 | 1 | 71 | 2016 | June | 25 | 14 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 236 | NULL | 0 | Transient | 120.0 | 0 | 0 | Canceled | 2016-04-27 | 89 |
| 4939 | 1 | 166 | 2016 | November | 45 | 1 | 0 | 3 | 1 | 0.0 | 0 | BB | PRT | Offline TA/TO | TA/TO | 0 | 0 | 0 | A | A | 0 | Non Refund | 236 | NULL | 0 | Transient | 110.0 | 0 | 0 | Canceled | 2016-07-13 | 85 |